Bill Jelen

Bill Jelen "Mr Excel" - 40 Greatest Excel Tips of All-Time Book

Order: Reorder
Duration: 42:39
Updated: 05 Aug 2015
views: 488

+Bill Jelen joins us to discuss the book that he co-wrote with Szilvia Juhasz. The discussion will include crowd-sourcing, book manufacturing, etc. Put the kids to bed, grab a cold one out of the fridge and we will see you at 9:05pm Eastern Time on Tuesday August 4th

wn.com/Bill Jelen Mr Excel 40 Greatest Excel Tips Of All Time Book

PowerPivot Data Analyst 1 - What is PowerPivot?

Order: Reorder
Duration: 4:44
Updated: 28 Aug 2014
views: 102823
author: Bill Jelen

Learn about the five benefits of PowerPivot in this introductory video from MrExcel. This video is designed to accompany the book, PowerPivot for the Data An...

wn.com/Powerpivot Data Analyst 1 What Is Powerpivot

Bill Jelen Interview - Mr Excel Expert Interview - MrExcel.com

Order: Reorder
Duration: 34:30
Updated: 13 Apr 2014
views: 1001

http://Excel.TV Bill Jelen of MrExcel.com joins us to discuss his business growth. This includes how he published his first book and why he built his publishing company Holy Macro. Bill further reviews how he started online. How to find Bill Jelen: Website: http://www.mrexcel.com/ Twitter: https://twitter.com/MrExcel Facebook: https://www.facebook.com/pages/MrExcel/21006183032 Youtube: https://www.youtube.com/user/bjele123 Excel TV SUBSCRIBE: http://www.youtube.com/user/ExcelTVShow Google Plus: https://plus.google.com/116533082132230113711/116533082132230113711 Facebook: https://www.facebook.com/ExcelTVSeries Twitter: https://twitter.com/ExcelTV Our Personal Sites: Website Rick Grantham: http://rickgrantham.com/ Jordan Goldmeier: http://optionexplicitvba.com Oz Du Soleil: http://datascopic.net Youtube: Oz Du Soleil: http://www.youtube.com/user/WalrusCandy Rick Grantham; http://www.youtube.com/MrRickGrantham Facebook: Rick Grantham: https://www.facebook.com/AuthorRickGrantham Jordan Goldmeier: https://www.facebook.com/OptionExplicitVBA Oz Du Soleil: http://facebook.com/devilhorse Google Plus: Oz Du Soleil: Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier Rick Grantham: https://plus.google.com/+RickGrantham LinkedIN: Jordan Goldmeier: http://www.linkedin.com/in/jordangoldmeier/ Oz Du Soleil: http://www.linkedin.com/in/ozdata Rick Grantham: http://www.linkedin.com/in/rickgrantham/ Twitter Oz Du Soleil: https://twitter.com/Oz_DragonCookie Rick Grantham: https://twitter.com/BIStrategyGuy Jordan Goldmeier: http://twitter.com/Option_Explicit Products: Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/ Jordan - Excel Consulting & Training http://www.GoldmeierConsulting.com http://www.ExcelAndAccess.com http://www.VBAExpress.com

wn.com/Bill Jelen Interview Mr Excel Expert Interview Mrexcel.Com

EXCEL TV Live Hangout - Episode 5 - Bill Jelen aka Mr Excel

Order: Reorder
Duration: 77:35
Updated: 02 Apr 2014
views: 1136

http://Excel.TV +Bill Jelen aka Mr Excel joins us for Episode 5 of Excel TV with your hosts +Rick Grantham +Jordan Goldmeier and +Oz du Soleil . This is our fifth LIVE show where we will discuss Excel Tips, Tricks and News. Do you have a question you would like for us to ask Mr Excel? If so, leave a comment below to let us know. Find out who won the Excel Brainteaser. So put the kids to bed, grab a drink and join our show

wn.com/Excel Tv Live Hangout Episode 5 Bill Jelen Aka Mr Excel

DIVOKEJ BLL & JELEN - ROZÁRKA (live)

Order: Reorder
Duration: 2:47
Updated: 17 Dec 2014
views: 3107

Akustické turné 16.12.2014 Praha Lucerna Music Bar

wn.com/Divokej Bll Jelen Rozárka (Live)

Divokej Bill / Předkapela - Jelen /Loket 31.7.2015

Order: Reorder
Duration: 3:32
Updated: 31 Jul 2015
views: 138

wn.com/Divokej Bill Předkapela Jelen Loket 31.7.2015

Learn Excel - Power Query - Podcast 1956

Order: Reorder
Duration: 10:49
Updated: 30 Sep 2015
views: 1183

This video, for Excel's 30th anniversary walks through what a game-changer Power Query is for Excel. You start with a folder full of horribly-formatted CSV files. Using the Query Editor, you load all of those files, clean the data, unpivot the data. Tomorrow, when more files are in the CSV folder, a simple Refresh will load and clean all of the data again. Power Query is built in to Excel 2016 under Data, Get & Transform or a free add-in for Excel 2010 and Excel 2013. Download from http://www.microsoft.com/en-us/download/details.aspx?id=39379 To try it out yourself with my files, download them from http://www.mrexcel.com/podcast1956.zip

wn.com/Learn Excel Power Query Podcast 1956

Excel Celebrity Death Match - Excel TV with Bill Jelen and Zack Barresse

Order: Reorder
Duration: 43:14
Updated: 20 Sep 2014
views: 399

http://Excel.TV Get Zack's Book here PDF Version - http://Excel.TV/likes/ExcelTables Hardcover - http://excel.tv/likes/161547028X Zack Barresse, Bill Jelen, Oz and Jordan square off in a Battle of the Ages. Pitting Excel knowledge against "development style" in this McLaughlin Group style debate. Carl Peppeerseed even makes a brief appearance. Zack's uses Bob Umlas' good looks to win the competition. How to find Zack Barresse: Twitter: https://twitter.com/zbarresse LinkedIN: https://www.linkedin.com/profile/view?id=2991969 Hire Zack: http://excelandaccess.wordpress.com/2013/05/10/zack-barresse-microsoft-excel-mvp/ Zack's MVP Page: http://mvp.microsoft.com/en-us/mvp/Zack%20Barresse-33475 How to find Bill Jelen: Website: http://www.mrexcel.com/ Twitter: https://twitter.com/MrExcel Facebook: https://www.facebook.com/pages/MrExcel/21006183032 Youtube: https://www.youtube.com/user/bjele123 Excel TV SUBSCRIBE: http://www.youtube.com/user/ExcelTVShow Google Plus: https://plus.google.com/116533082132230113711/116533082132230113711 Facebook: https://www.facebook.com/ExcelTVSeries Twitter: https://twitter.com/ExcelTV LinkedIN: https://www.linkedin.com/groups/Excel-TV-7473731 Our Personal Sites: Website Rick Grantham: http://rickgrantham.com/ Jordan Goldmeier: http://optionexplicitvba.com Oz Du Soleil: http://datascopic.net Youtube: Oz Du Soleil: http://www.youtube.com/user/WalrusCandy Rick Grantham; http://www.youtube.com/MrRickGrantham Facebook: Rick Grantham: https://www.facebook.com/AuthorRickGrantham Jordan Goldmeier: https://www.facebook.com/OptionExplicitVBA Oz Du Soleil: http://facebook.com/devilhorse Google Plus: Oz Du Soleil: Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier Rick Grantham: https://plus.google.com/+RickGrantham LinkedIN: Jordan Goldmeier: http://www.linkedin.com/in/jordangoldmeier/ Oz Du Soleil: http://www.linkedin.com/in/ozdata Rick Grantham: http://www.linkedin.com/in/rickgrantham/ Twitter Oz Du Soleil: https://twitter.com/Oz_DragonCookie Rick Grantham: https://twitter.com/BIStrategyGuy Jordan Goldmeier: http://twitter.com/Option_Explicit Products: Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/ Jordan - Excel Consulting & Training http://www.GoldmeierConsulting.com

wn.com/Excel Celebrity Death Match Excel Tv With Bill Jelen And Zack Barresse

VLookup In Plain English

Order: Reorder
Duration: 2:38
Updated: 25 Aug 2014
views: 11191
author: Bill Jelen

Bill starts from the beginning; why to use a VLOOKUP, when to use a VLOOKUP and how to Use a VLOOKUP. If you are ready to unravel the mystery of VLOOKUP, fol...

wn.com/Vlookup In Plain English

Bill Jelen: "From 1979 -- VisiCalc and LOOKUP"!

Order: Reorder
Duration: 4:04
Updated: 19 Dec 2012
views: 1732
author: Bill Jelen

You read correctly -- 1979. In Bill's last installment for VLOOKUP WEEK 2012, we go back to 1979...VisiCalc and the whole '20 Functions' available in that ti...

wn.com/Bill Jelen From 1979 Visicalc And Lookup

Learn Excel 2010 - "Next Invoice Number": Podcast #1505

Order: Reorder
Duration: 6:06
Updated: 03 Sep 2014
views: 75179
author: Bill Jelen

The Question: "How do I generate the next Invoice Number?" Microsoft Office Online offers a great number of Invoice Templates. However, none of those templat...

wn.com/Learn Excel 2010 Next Invoice Number Podcast 1505

Q&A; with Mr Excel - Bill Jelen Answers Questions

Order: Reorder
Duration: 8:30
Updated: 16 Aug 2015
views: 13

http://Excel.TV In a 2013 dinner meeting with Mr Excel, Excel Blogger Chandoo asked his audience for what questions he should ask Bill. Szilvia asks these questions. Excel TV SUBSCRIBE: http://www.youtube.com/user/ExcelTVShow Google Plus: https://plus.google.com/116533082132230113711/116533082132230113711 Facebook: https://www.facebook.com/ExcelTVSeries Twitter: https://twitter.com/ExcelTV Instagram: https://instagram.com/excel.tv/ Groups LinkedIN Group: https://www.linkedin.com/groups/Excel-TV-7473731?gid=7473731 Facebook Group: https://www.facebook.com/groups/621480787922563/ G+ Group: https://plus.google.com/u/0/b/116533082132230113711/communities/104377509602717128191 Our Personal Sites: Website Rick Grantham: http://rickgrantham.com/ Jordan Goldmeier: http://optionexplicitvba.com Youtube: Rick Grantham; http://www.youtube.com/MrRickGrantham Facebook: Rick Grantham: https://www.facebook.com/AuthorRickGrantham Jordan Goldmeier: https://www.facebook.com/OptionExplicitVBA Google Plus: Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier Rick Grantham: https://plus.google.com/+RickGrantham LinkedIN: Jordan Goldmeier: http://www.linkedin.com/in/jordangold... Rick Grantham: http://www.linkedin.com/in/rickgrantham/ Twitter: Rick Grantham: https://twitter.com/BIStrategyGuy Jordan Goldmeier: http://twitter.com/Option_Explicit Products: Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/ Jordan - Excel Training - http://www.CambiaFactor.com

wn.com/Q A With Mr Excel Bill Jelen Answers Questions

PowerPivot Data Analyst 11 - Time Intelligence

Order: Reorder
Duration: 3:15
Updated: 29 Aug 2014
views: 14585
author: Bill Jelen

Use the DAX time intelligence functions to create MTD Revenue in a PowerPivot Pivot Table. This video is designed to accompany the book, PowerPivot for the D...

wn.com/Powerpivot Data Analyst 11 Time Intelligence

Episode 015 with Bill Jelen aka Mr Excel and Zack Barresse

Order: Reorder
Duration: 68:37
Updated: 21 Aug 2014
views: 647

http://Excel.TV Get Zack's Book here PDF Version - http://Excel.TV/likes/ExcelTables Hardcover - http://Excel.TV/likes/161547028X Wow. This was a fun show. Both Bill Jelen aka Mr Excel and Zack Barresse author of the book "Excel Tables" joined the show. In this show we jumped from topic to topic debating different Excel topics. Book mark this show. How to find Zack Barresse: Twitter: https://twitter.com/zbarresse LinkedIN: https://www.linkedin.com/profile/view?id=2991969 Hire Zack: http://excelandaccess.wordpress.com/2013/05/10/zack-barresse-microsoft-excel-mvp/ Zack's MVP Page: http://mvp.microsoft.com/en-us/mvp/Zack%20Barresse-33475 How to find Bill Jelen: Website: http://www.mrexcel.com/ Twitter: https://twitter.com/MrExcel Facebook: https://www.facebook.com/pages/MrExcel/21006183032 Youtube: https://www.youtube.com/user/bjele123 Excel TV SUBSCRIBE: http://www.youtube.com/user/ExcelTVShow Google Plus: https://plus.google.com/116533082132230113711/116533082132230113711 Facebook: https://www.facebook.com/ExcelTVSeries Twitter: https://twitter.com/ExcelTV LinkedIN: https://www.linkedin.com/groups/Excel-TV-7473731 Our Personal Sites: Website Rick Grantham: http://rickgrantham.com/ Jordan Goldmeier: http://optionexplicitvba.com Oz Du Soleil: http://datascopic.net Youtube: Oz Du Soleil: http://www.youtube.com/user/WalrusCandy Rick Grantham; http://www.youtube.com/MrRickGrantham Facebook: Rick Grantham: https://www.facebook.com/AuthorRickGrantham Jordan Goldmeier: https://www.facebook.com/OptionExplicitVBA Oz Du Soleil: http://facebook.com/devilhorse Google Plus: Oz Du Soleil: Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier Rick Grantham: https://plus.google.com/+RickGrantham LinkedIN: Jordan Goldmeier: http://www.linkedin.com/in/jordangoldmeier/ Oz Du Soleil: http://www.linkedin.com/in/ozdata Rick Grantham: http://www.linkedin.com/in/rickgrantham/ Twitter Oz Du Soleil: https://twitter.com/Oz_DragonCookie Rick Grantham: https://twitter.com/BIStrategyGuy Jordan Goldmeier: http://twitter.com/Option_Explicit Products: Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/ Jordan - Excel Consulting & Training http://www.GoldmeierConsulting.com

wn.com/Episode 015 With Bill Jelen Aka Mr Excel And Zack Barresse

Excel TV - Episode 05 Trailer with Bill Jelen Mr Excel

Order: Reorder
Duration: 1:07
Updated: 10 Jun 2014
views: 44
author: Excel TV

wn.com/Excel Tv Episode 05 Trailer With Bill Jelen Mr Excel

Learn Excel - Compile Error - Now What? Podcast 1820

Order: Reorder
Duration: 4:35
Updated: 01 Nov 2013
views: 539

You copied some Excel VBA code from the Internet, but when you try to run it, you get a compile error with Sub or Function Not Defined. This video shows you what might be causing that error and how to find the line to fix.

wn.com/Learn Excel Compile Error Now What Podcast 1820

Learn Excel 2013 -"ISODD": Podcast #1683

Order: Reorder
Duration: 3:16
Updated: 22 Nov 2013
views: 1454
author: Bill Jelen

Mr. and Mrs.Excel are House shopping in Florida. And how does Bill prefer to look over the details? In Microsoft Excel, of course. Today, in Episode #1683, B...

wn.com/Learn Excel 2013 Isodd Podcast 1683

Compare 2 Lists with a VLOOKUP

Order: Reorder
Duration: 3:45
Updated: 11 Jun 2013
views: 4747
author: Bill Jelen

In the spirit of "VLOOKUP WEEK 2012" [march 25th - March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I hav...

wn.com/Compare 2 Lists With A Vlookup

Learn Excel - Ugly Web Data into Excel with Power Query - Podcast 1947

Order: Reorder
Duration: 3:12
Updated: 05 Feb 2015
views: 203

After trying to scrape some data from a web table into Excel, some modern web trickery is causing the data to copy to the clipboard in a way that all the data pastes into a single cell in Excel. Power Query comes to the rescue, pulling the data correctly into Excel.

wn.com/Learn Excel Ugly Web Data Into Excel With Power Query Podcast 1947

Divokej Bill - Rozárka

Order: Reorder
Duration: 2:50
Updated: 09 Aug 2013
views: 146218
author: blbusticka

wn.com/Divokej Bill Rozárka

MegaMillions Lottery - 453 - Learn Excel from MrExcel Podcast

Order: Reorder
Duration: 3:46
Updated: 18 Aug 2014
views: 7317
author: Bill Jelen

After Scotts question for tomorrows podcast, I thought it would be cool to see how a pivot table could analyze the most popular lottery numbers. The MegaMill...

wn.com/Megamillions Lottery 453 Learn Excel From Mrexcel Podcast

Excel VBA 2 - Defined Constants

Order: Reorder
Duration: 2:42
Updated: 01 Mar 2013
views: 2904
author: Bill Jelen

An explanation of how defined constants such as XLRight make life easier in VBA.

wn.com/Excel Vba 2 Defined Constants

Learn Excel - Unpivot with Power Query - Podcast 1909

Order: Reorder
Duration: 3:35
Updated: 14 Aug 2014
views: 393

Pivot tables are great when the source data is formatting correctly. But today, our data set has the Quarter field stretching across the columns instead of down the rows. This creates an awkward pivot table. The old solutions (see episodes 1787 and 705) took a lot of manual effort. Today, I show how the Power Query tool for Excel 2010 and Excel 2013 make this incredibly easy.

wn.com/Learn Excel Unpivot With Power Query Podcast 1909